project1

Tables (12)

tbl_board

  • id — INT — Primary key — NOT NULL — id
  • type_id — INT — Foreign key → tbl_board_type.id — NOT NULL
  • user_id — INT — Foreign key → tbl_user.id — NOT NULL — id
  • title — VARCHAR(250)
  • content — VARCHAR(2000)
  • isPublic — INT
  • password — VARCHAR(20)

tbl_board_type

  • id — INT — Primary key — NOT NULL
  • type — VARCHAR(25)

tbl_comment

  • id — INT — Primary key — NOT NULL
  • user_id — INT — Foreign key → tbl_user.id — NOT NULL — id
  • board_id — INT — Foreign key → tbl_board.id — NOT NULL — id
  • comment — VARCHAR(250)

tbl_fm_with_food

  • id — INT — Primary key — NOT NULL
  • food_id — INT — Foreign key → tbl_food.id — NOT NULL — id
  • fm_id — INT — Foreign key → tbl_food_management.id — NOT NULL

tbl_food

  • id — INT — Primary key — NOT NULL — id
  • food_name — VARCHAR(45) — food_name
  • carbohydrate — INT — carbohydrate
  • protein — INT — protein
  • brand — VARCHAR(45) — brand
  • fat — INT — fat
  • kcal — INT — kcal
  • id_user — INT — id_user

tbl_food_management

  • id — INT — Primary key — NOT NULL
  • user_id — INT — Foreign key → tbl_user.id — NOT NULL — id
  • purpose_id — INT — Foreign key → tbl_purpose.id — NOT NULL
  • date — DATE
  • weight — DOUBLE
  • acitive_point (active_point) — DOUBLE

tbl_point

  • id — INT — Primary key — NOT NULL
  • user_id — INT — Foreign key → tbl_user.id — NOT NULL — id
  • point — INT
  • reason — VARCHAR(50)
  • regist_time — DATETIME

tbl_purpose (Untitled)

  • id — INT — Primary key — NOT NULL
  • purpose — VARCHAR(15)

tbl_room

  • id — INT — Primary key — NOT NULL — id
  • type_id — INT — Foreign key → tbl_room_type.id — NOT NULL
  • user_id — INT — Foreign key → tbl_user.id — NOT NULL — id
  • title — VARCHAR(30) — title
  • content — VARCHAR(200)
  • is_public — INT
  • password — VARCHAR(30)
  • chat — TEXT
  • open_time — DATETIME — openTime
  • close_time — DATETIME — closeTime
  • limit_user — INT

tbl_room_join_user

  • id — INT — Primary key — NOT NULL — id
  • user_id — INT — Foreign key → tbl_user.id — NOT NULL — id
  • room_id — INT — Foreign key → tbl_room.id — NOT NULL — id

tbl_room_type

  • id — INT — Primary key — NOT NULL
  • type — VARCHAR(25)

tbl_user

  • id — INT — Primary key — NOT NULL — id
  • purpose_id — INT — Foreign key → tbl_purpose.id — NOT NULL
  • email — VARCHAR(45) — NOT NULL — email
  • name — VARCHAR(45) — NOT NULL — name
  • nickname — VARCHAR(45) — NOT NULL — nickname
  • password — VARCHAR(45) — NOT NULL — password
  • isWithdraw — INT — NOT NULL — isWithdraw
  • withdraw_reason — VARCHAR(200) — NOT NULL — withdraw_reason
  • weight — DOUBLE
  • active_point — DOUBLE