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