ODP

Tables (5)

comment (댓글)

  • id (PK) — BIGINT — Primary key — NOT NULL
  • content (Field) — TEXT
  • created_at (Field2) — DATE
  • user_id (PK2) — BIGINT — Foreign key → user_table.id
  • review_id (PK3) — BIGINT — Foreign key → review.id — NOT NULL

plan (계획)

  • id (PK) — BIGINT — Primary key — NOT NULL
  • title (Field) — VARCHAR(255)
  • start_date (Field2) — DATE
  • end_date (Field3) — DATE
  • description (Field4) — VARCHAR(255)
  • create_at (Field5) — DATE
  • modified_at (Field6) — DATE
  • user_id (PK2) — BIGINT — Foreign key → user_table.id

plan_detail (여행지)

  • id (PK) — BIGINT — Primary key — NOT NULL
  • name (Field) — VARCHAR(255)
  • location (Field7) — VARCHAR(255)
  • lat (Field2) — DECIMAL(9,6)
  • lng (Field3) — DECIMAL(9,6)
  • img (Field4) — VARCHAR(2048)
  • day (Field5) — TINYINT UNSIGNED
  • seq (Field6) — TINYINT UNSIGNED
  • plan_id (PK2) — BIGINT — Foreign key → plan.id — NOT NULL

review (후기)

  • id (PK) — BIGINT — Primary key — NOT NULL
  • title (Field) — VARCHAR(50)
  • content (Field2) — TEXT
  • locate (Field7) — VARCHAR(50)
  • img (Field3) — VARCHAR(2048)
  • created_at (Field4) — DATE
  • modified_at (Field8) — DATE
  • is_public (Field5) — TINYINT(1)
  • view (Field6) — INT
  • user_id (PK2) — BIGINT — Foreign key → user_table.id
  • id (PK3) — BIGINT — Foreign key → plan.id — NOT NULL

user_table (유저)

  • id (PK) — BIGINT — Primary key
  • email (Field) — VARCHAR(50)
  • password (Field2) — VARCHAR(50)
  • name (Field3) — VARCHAR(30)
  • birthday (Field4) — DATE