boarding

Tables (3)

Comment (Untitled3)

  • comment_id — BIGINT — Primary key — NOT NULL
  • created_date — TIMESTAMP — NOT NULL
  • modified_date — TIMESTAMP — NOT NULL
  • is_removed — TINYINT — NOT NULL
  • post_id — BIGINT — NOT NULL
  • content — CLOB — NOT NULL
  • user_id (id2) — BIGINT — Foreign key → User.user_id — NOT NULL — AutoIncrement
  • parent_id (comment_id2) — BIGINT — Foreign key → Comment.comment_id — NOT NULL

Post (Untitled2)

  • post_id — BIGINT — Primary key — NOT NULL — autoincrement
  • title — VARCHAR(255) — NOT NULL
  • content — CLOB — NOT NULL
  • user_id (writer_id) — BIGINT — Foreign key → User.user_id — NOT NULL — AutoIncrement
  • created_date — TIMESTAMP — NOT NULL
  • modifed_date (modified_date) — TIMESTAMP — NOT NULL
  • file_path — VARCHAR(255)

User (Untitled)

  • user_id (id) — BIGINT — Primary key — NOT NULL — AutoIncrement
  • Created_date — TIMESTAMP — NOT NULL — Updatable = False
  • Modified_date — TIMESTAMP — NOT NULL
  • nickname — VARCHAR(20) — NOT NULL
  • Role — VARCHAR(10) — NOT NULL
  • name — VARCHAR(20) — NOT NULL
  • email — VARCHAR(40) — NOT NULL
  • password — VARCHAR(40) — NOT NULL
  • age (Field) — INT — NOT NULL
  • refreshtoken (refresh_token) — varchar(1000) — NOT NULL