LOLCW
Tables (4)
group
- group_seq — int8 — Primary key — NOT NULL
- created_date — timestamp
- modified_date — timestamp
- group_name — varchar(30)
- owner — varchar(30)
group_invite
- group_invite_seq — int8 — Primary key — NOT NULL
- group_seq — int8 — Foreign key → group.group_seq — NOT NULL
- user_seq — int8 — Foreign key → web_user.user_seq — NOT NULL
- invited_date — timestamp
- modified_date — timestamp
- invited_user_seq — int8
- invite_result — bool
- expire_result — bool — NOT NULL
user_alarm
- alarm_seq — int8 — Primary key — NOT NULL
- user_seq — int8 — Foreign key → web_user.user_seq — NOT NULL
- group_invited_seq — int8 — Foreign key → group_invite.group_invite_seq — NOT NULL
- created_date — timestamp
- modified_date — timestamp
- alarm_type — varchar(255)
- is_delete — bool
- is_read — bool
- landing_url — varchar(255)
- message — varchar(255)
web_user
- user_seq — int8 — Primary key — NOT NULL
- created_date — timestamp
- modified_date — timestamp
- authority — varchar(255)
- password — varchar(255)
- user_id — varchar(255)
- confirm — bool
- email — varchar(255)
- refresh_token — varchar(200)
- lolcw_tag — varchar(20)