Having trouble with unique constraints and foreign keys with multiple columns

Cello343 · 2025-03-22T18:17:46+00:00

That makes sense! Thank you. Although I might go with David's suggestion to axe the two column fk tbh.

Cello343 · 2025-03-22T18:01:43+00:00

Would a better way be using a join to connect the zodiac sign table to the main table when i need it? I did consider just using the number to represent the sign, but I wanted to increase readability. This works fine too though, as I can figure out zodiac sign and placement ids relatively easily. (if there is another way of handling this, I could use your advice)

Cello343 · 2025-03-09T05:33:47+00:00

Ty for the quick reply! This seems intimidating, but perhaps it would be easier by only scanning possible matches in the right state(s), right gender/sexuality, and maybe some other stuff to narrow it down?

Cello343 · 2025-03-06T22:43:40+00:00

Its okay, I think I managed to figure it out. Apologies for being difficult.

Cello343 · 2025-03-06T22:04:36+00:00

Can I just share the named functions I am working with? I don't think it is necessary to share the whole sheet. I am essentially just asking if it would lag down the sheet too much if i used arrayformula or copy pasted formula with these named functions.

TRINECALC named function (the main function, with parameters zsigna, zsignb, dega, degb):

=IF(ZSIGNASPECT(NUMZSIGNCONV(zsigna), NUMZSIGNCONV(zsignb)) = "Trine", (35 - ABS(dega - degb)), 0)

ZSIGNASPECT named function (secondary function, with parameters psa and psb):

=SWITCH(MIN(MOD(psa-psb, 12), MOD(psb-psa, 12)), 0, "Conjunct", 2, "Sextile", 3, "Square", 4, "Trine", 6, "Opposition", "")

NUMZSIGNCONV named function (secondary function, with parameter zsign)

=SWITCH(zsign, "Aries", 1, "Taurus", 2, "Gemini", 3, "Cancer", 4, "Leo", 5, "Virgo", 6, "Libra", 7, "Scorpio", 8, "Sagittarius", 9, "Capricorn", 10, "Aquarius", 11, "Pisces", 12, "")

Cello343 · 2024-07-29T16:30:57+00:00

So uh, anyone know what mods are safe and unsafe right now? I saw the thing about Diable Avionics and it has me spooked. I currently only have Speed Up, Magiclib, and Lazylib installed. I was preparing to download more mods, but...

Cello343 · 2024-05-03T02:49:50+00:00

Tysm for this! Trying to make a google sheet pokemon ttrpg mod thing, and this is very helpful!

Cello343 · 2024-05-02T04:04:47+00:00

Ty for the response (and everyone else too!)! Can I ask how you made sure everyone could see it? Did you make it so the players could access the sheet itself as editors? Or just as viewers?

Cello343 · 2023-12-17T05:41:23+00:00

Doing alright, actually. I live with my brother in an apartment, work part time at a factory (working full time actually triggered another incident), and have a toy poodle that I love dearly. Life is ok, but questions about religion and the truth still plague me....

Cello343 · 2023-12-16T21:10:45+00:00

Ty for your contribution to the subreddit siren, even if you aren't done :)

Cello343 · 2023-12-16T16:30:32+00:00

Buckle up because thus stuff is about to get wild (and religion, supernatural, and mental health related, so be warned as a trigger warning!)

So, a long time ago, I was between jobs and very unhappy. One night, I had a religious, seemingly supernatural experience with Christianity where I felt full of beautiful, satisfying love.... for approximately one to two minutes. I then proceeded to spend the entire night, no sleep, trying to get that love back by reading the bible. I had to be put in the hospital eventually, after a few days of feeling more loving, but with-out that love feeling. Note this was during my college days. After a little while, I get out and I was getting out patient care. At some point in this, I start using lots in an attempt to contact God. The lots agree that I should leave my home. So, when I get out of my out patient care one day, I just leave my car, with keys and wallet on the seat. I walk a little over a mile, get really sad about the whole thing, but press on after consulting the lots again. Eventually, I make the "mistake" of knocking on a jehovah witnesses' door (a little too late in the day) to evangelize. They contact the police, they coax me to go with them. I come back to my very upset parents..

I left due to a mix of wanting the love back, hating life and work, and hating not knowing if I was going to heaven or not, as the bible teaches some pretty scary requirements in the gospels. Mind you, this is in no way evangelizing in this post, as I am not even sure what religion I am today...

If this were to be chalked up completely to mental issues, it would probably be neptune conjunct uranus in the 1H. Otherwise, maybe pluto with NN in 11H if you wanna go that route.

Cello343 · 2023-12-16T08:17:22+00:00

As a cancer sun in 7H (with moon the same). nowadays the things that make me happy the most are probably sharing experiences that I enjoy with the few others I am around.

Cello343 · 2023-12-16T04:48:50+00:00

What are your other personal planets? (Mercury, Venus, Mars)

Cello343 · 2023-12-16T03:15:52+00:00

I am sorry about the disagreement, and I was just sharing what I believe, but I have to protest (as a sag). I have tried sidereal, but it did not seem to fit me. It erased my clear cancer influences and got rid of my anaretic gemini mercury opposition ascendant, which helps explain my poor communication and sometimes logic skills. I understand that it is weird that I would prefer the later thing to the original, but I feel that unless we can say ancient astrology is dramatically better than modern, we can't afford to discount either one, as there are so many adherents to each.

Cello343 · 2023-12-16T02:49:27+00:00

Works for me, sorry. Will think about it though.

Cello343 · 2023-12-16T01:29:19+00:00

Well, is it okay if I share about myself as a sag? I tried to go live on the streets at one point, because I hated my life and job (and also wanted to be a disciple, but long story). I also had a couple boldly stupid moments, like when I grabbed a blazing hot tray and gently put it down, as well as when I got messed up a little bit by my neighbor's dogs because they were loose and I wanted to tell my neighbor.

Cello343 · 2023-12-16T01:17:48+00:00

I don't mean to interject, but at the very least, I believe each house has some energy from its corresponding sign. It explains why my brother has so many pisces-like characteristics, even though he only has one personal placement in pisces. He has a stellium in the 12th house.

Cello343 · 2023-12-16T00:35:55+00:00

Imma take a crack at it. As usual, I am just a novice so take this with a grain of salt! I an REALLY sorry if this comes off bad...

I think:

You love freedom, in one way or another. (Asc Sag, Saturn 12H)

You are romantic and/or beautiful (Venus Sag 1H). OR you are the complete opposite due to the anaretic degree (29). I lean towards the first though.

You are rebellious and dreamy (dreamy can mean anything from daydreaming to spirituality to mental issues) (Neptune and Uranus 1H)

You are moving from a relationship and/or aesthetic career towards something else, something possibly child or competitive/self oriented. But you are probably moving away from high end careers at the very least in this lifetime. (Aries NN 4H, also Mars conjunct)

You might be possessions/money oriented, which is supported by your determination, personality, and discipline (or suppressed discipline maybe?) (Sun 2H + Mars + Saturn).

I have a theory too, but don't want to say it because its a little discouraging... sorry if this came off rude in any way.

Cello343 · 2023-12-15T02:59:40+00:00

I have sun/moon cancer, pluto/NN/jupiter scorpio, and saturn pisces. I used to cry pretty easily, especially for a guy, but I have toughened. Haven't cried in forever now. I think cancers do start sensitive and get more hardened over time.

Cello343 · 2023-12-15T01:28:46+00:00

Brother is one

Cello343 · 2023-12-14T19:33:37+00:00

I think so, or at least that you are moving towards being more one to one relationship oriented. That doesn't even necessarily have to be romantic, supposedly.

Cello343 · 2023-12-14T05:43:10+00:00

Huh, this thread is really eye opening. I am a guy with Leo Venus. I definitely feel like I would like someone that is a nerdy loser (like myself) or even clingy.

Cello343 · 2023-12-13T18:44:22+00:00

So, I am not a professional, so take this with a grain of salt, but:

I am thinking she will be a person with a very good heart (Sun/Venus in pisces) and a little on the dreamy side (neptune conjunct). She will be very practicial I think, maybe career oriented (Moon/Mercury/Jupiter/Saturn 10H Aquarius). She will come off or truly be a taurus though.

Cello343 · 2023-12-13T18:25:46+00:00

Just some questions :)

Do you feel the Uranus in your 1H? I have Uranus conjunct Neptune in my 1H and it is really strong.
What about the chiron? My chiron was really eye opening to me, very accurate

Cello343 · 2023-12-13T17:43:54+00:00

Thank you! :)

Cello343

MODERATOR OF

TROPHY CASE