220627_1

Tables (5)

fee (Untitled4)

  • Fee_id (id) — NOT NULL — Primary key — NOT NULL
  • fine (벌금) — NOT NULL
  • prize (상금) — NOT NULL
  • Plan_id (id2) — NOT NULL — Foreign key → plan.Plan_id — NOT NULL

plan (Untitled3)

  • Plan_id (id) — NOT NULL — Primary key — NOT NULL
  • period (주기) — NOT NULL
  • percent (달성률) — NOT NULL
  • Room_id (id2) — NOT NULL — Foreign key → room.Room_id — NOT NULL
  • User_id — NOT NULL — Foreign key → user.User_id — NOT NULL

room (Untitled2)

  • Room_id (id) — NOT NULL — Primary key — NOT NULL
  • duration (기간) — NOT NULL
  • title (제목) — NOT NULL
  • Create_time (생성시간) — NOT NULL
  • Modify_time (수정시간) — NOT NULL
  • Room_num (방코드) — NOT NULL
  • Entry_fee (참가비) — NOT NULL

user (Untitled)

  • User_id — NOT NULL — Primary key — NOT NULL
  • password (비밀번호) — NOT NULL
  • nickname (닉네임) — NOT NULL
  • id (아이디) — NOT NULL

user_room (Untitled5)

  • User_id — NOT NULL — Foreign key → user.User_id — NOT NULL
  • Room_id (id2) — NOT NULL — Foreign key → room.Room_id — NOT NULL