ㅁㄴㅇ

Tables (3)

card

  • card_id — BIGINT(20) — NOT NULL
  • cardCompany — VARCHAR(45) — NOT NULL
  • cardNumber — VARCHAR(45) — NOT NULL
  • name — VARCHAR(45) — NOT NULL
  • extendedDate — TIMESTAMP — NOT NULL
  • paymentDate — TIMESTAMP — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP
  • isSpare — TINYINT(1) — NOT NULL
  • status — TINYINT(1) — NOT NULL
  • user_id — BIGINT(20) — NOT NULL

profile

  • profile_id — BIGINT(20) — NOT NULL
  • user_id — BIGINT(20) — NOT NULL
  • name — VARCHAR(45) — NOT NULL
  • password — VARCHAR(45) — NOT NULL
  • grade — INT — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP

users

  • user_id — BIGINT(20) — NOT NULL
  • email — VARCHAR(45) — NOT NULL
  • password — VARCHAR(45) — NOT NULL
  • phone — VARCHAR(45) — NOT NULL
  • status — VARCHAR(45) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP
  • birthday — DATE — NOT NULL
  • membershipID — BIGINT(20) — NOT NULL
  • region_id — BIGINT(20) — NOT NULL