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)