Lost42

Tables (4)

BOARD (Untitled2)

  • board_id (Key) — BIGINT — Primary key — NOT NULL
  • user_id (Key2) — BIGINT — Foreign key → MEMBER.member_id — NOT NULL
  • category_id (Key3) — BIGINT — Foreign key → Category.category_id — NOT NULL
  • name (Field) — VARCHAR2(50) — NOT NULL
  • image (Field2) — BLOB
  • found_at (Field3) — VARCHAR2(50) — NOT NULL
  • found_date (Field4) — VARCHAR2(50) — NOT NULL
  • keeping_at (Field5) — VARCHAR2(50)
  • contract (Field13) — VARCHAR2(13)
  • description (Field6) — VARCHAR2(500)
  • managed_number (Field7) — VARCHAR2(100)
  • status (Field8) — TINYINT — NOT NULL
  • type (Field9) — VARCHAR2(10) — NOT NULL
  • created_dt (Field10) — DATETIME — NOT NULL
  • updated_dt (Field11) — DATETIME — NOT NULL
  • deleted_dt (Field12) — DATETIME

Category (Untitled3)

  • category_id (Key) — BIGINT — Primary key — NOT NULL
  • name (Field) — VARCHAR2(50) — NOT NULL
  • created_dt (Field2) — DATETIME — NOT NULL
  • updated_dt (Field3) — DATETIME — NOT NULL
  • deleted_dt (Field4) — DATETIME

MEMBER (Untitled)

  • member_id (Key) — BIGINT — Primary key — NOT NULL
  • email (BIGINT) — VARCHAR2(50) — NOT NULL
  • name (Field2) — VARCHAR2(20) — NOT NULL
  • password (Field3) — VARCHAR2(200)
  • oauth_id (Field4) — BIGINT
  • oauth_provider (Field) — VARCHAR(20)
  • refresh_token (Field5) — VARCHAR2(100)
  • role (Field7) — TINYINT — NOT NULL
  • created_dt (Field6) — DATETIME — NOT NULL
  • updated_dt (Field8) — DATETIME — NOT NULL
  • deleted_dt (Field9) — DATETIME

MEMBER_KEYWORD (Untitled4)

  • member_keyword_id (Key) — BIGINT — Primary key — NOT NULL
  • member_id (Key2) — BIGINT — Foreign key → MEMBER.member_id — NOT NULL
  • category_id (Key3) — BIGINT — Foreign key → Category.category_id — NOT NULL
  • created_dt (Field) — DATETIME — NOT NULL
  • updated_dt (Field2) — DATETIME — NOT NULL
  • deleted_dt (Field3) — DATETIME