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