sinhan

Tables (5)

Calendar (calendar)

  • calendarId (calendar_id) — BIGINT — Primary key — NOT NULL — Auto-increment
  • userId (user_id) — BIGINT — Primary key — NOT NULL — Auto-increment
  • date — datetime — NOT NULL
  • comment — varchar(100)

Celebrity (celebrity)

  • celebrityId (celebrity_id) — BIGINT — Primary key — NOT NULL — Auto-increment
  • name — varchar(20) — NOT NULL
  • instaId (insta_id) — varchar(20) — NOT NULL

User (user)

  • userId (user_id) — BIGINT — Primary key — NOT NULL — Auto-increment
  • userName (user_name) — varchar(20) — NOT NULL
  • email — varchar(20) — NOT NULL — UNIQUE
  • password — varchar(20)

celebAccount (celeb_account)

  • id — BIGINT — Primary key — NOT NULL — Auto-increment
  • userId (user_id) — BIGINT — Primary key — NOT NULL — Auto-increment
  • celebrityId (celebrity_id) — BIGINT — Primary key — NOT NULL — Auto-increment
  • amount — BIGINT — NOT NULL

targetAccount (target_account)

  • id — BIGINT — Primary key — NOT NULL — Auto-increment
  • userId (user_id) — BIGINT — Primary key — NOT NULL — Auto-increment
  • targetAmount (target_amount) — BIGINT — NOT NULL
  • amount — BIGINT — NOT NULL