user
Tables (4)
QuestionBoard (quertion_board)
- boardSeq (board_seq) — BIGINT — Primary key — NOT NULL
- userId (user_id) — VARCHAR(50) — Foreign key → User.userId — NOT NULL
- title — VARCHAR(50)
- content — VARCHAR(5000)
- answer — VARCHAR(5000)
- state — VARCHAR(50)
- writedate — VARCHAR(50)
SurviceHistory (service_history)
- historySeq (history_seq) — BIGINT — Primary key — NOT NULL
- userId (user_id) — VARCHAR(50) — Foreign key → User.userId — NOT NULL
- subtype — VARCHAR(50) — Foreign key → service.subtype — NOT NULL
- subStart (sub_start) — VARCHAR(50)
- subEnd (sub_end) — VARCHAR(50)
User (user)
- userId (user_id) — VARCHAR(50) — Primary key — NOT NULL
- userPassword (user_password) — BIGINT
- userNickname (user_nickname) — VARCHAR(50)
- phone — VARCHAR(50)
- address — VARCHAR(200)
service
- subtype — VARCHAR(50) — Primary key — NOT NULL
- price — BIGINT
- term — BIGINT