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