seocond

Tables (21)

ADDRESS_INFO

  • Key (ADDR_SEQ) — BIGINT — Primary key — NOT NULL
  • Key (MEMBER_SEQ) — BIGINT — Foreign key → Untitled.Key — NOT NULL
  • Field (POST_NO) — VARCHAR(10) — NOT NULL
  • Field (ADDR_H) — VARCHAR(200) — NOT NULL
  • Field (ADDR_D) — VARCHAR(200) — NOT NULL
  • Field (DEFAULT_YN) — SMALLINT — NOT NULL
  • Field (ADDR_NM) — VARCHAR(50) — NOT NULL

Untitled (ALARAM)

  • Key (ALARM_SEQ) — BIGINT — Primary key — NOT NULL
  • Field (SENT_DTM) — TIMESTAMP
  • Field (ALARM_CONT) — VARCHAR(500)
  • Key (CHAT_MSG_SEQ) — BIGINT — Foreign key → Untitled.Key — NOT NULL
  • Key (CHAT_ROOM_SEQ) — BIGINT — Foreign key → Untitled.Key — NOT NULL
  • Key (TRADE_SEQ) — BIGINT — Foreign key → Untitled.Key — NOT NULL
  • Key (MEMBER_SEQ) — BIGINT — Foreign key → Untitled.Key — NOT NULL

Untitled (MEMBER_OAUTH)

  • Key (MEMBER_OAUTH_SEQ) — BIGINT — Primary key — NOT NULL
  • Field (PROVIDER) — ENUM
  • Field (CONNECTED_DT) — DATE
  • Key (MEMBER_SEQ) — BIGINT — Foreign key → Untitled.Key — NOT NULL

Untitled (BOOK_CLUB_BOARD)

  • Key (BOOK_CLUB_BOARD_SEQ) — BIGINT — Primary key — NOT NULL
  • Key (BOOK_CLUB_SEQ) — BIGINT — Foreign key → Untitled.Key — NOT NULL
  • Field (BOARD_TITLE) — VARCHAR(200)
  • Field (BOARD_CONT) — TEXT
  • Field (BOARD_IMG_URL) — VARCHAR(500)
  • Field (BOARD_DELETED_YN) — BOOLEAN
  • Field (BOARD_DELETED_DTM) — TIMESTAMP
  • Key (PARENT_BOOK_CLUB_BOARD_SEQ) — BIGINT — Foreign key → Untitled.Key — NOT NULL
  • Key (BOOK_CLUB_SEQ2) — BIGINT — Foreign key → Untitled.Key — NOT NULL
  • Key (MEMBER_SEQ) — BIGINT — Foreign key → Untitled.Key — NOT NULL
  • Key (BOOK_INFO_SEQ) — BIGINT — Foreign key → Untitled2.Key — NOT NULL

Untitled (BOOK_CLUB_MEMBER)

  • Key (BOOK_CLUB_MEMBER_SEQ) — BIGINT — Primary key — NOT NULL
  • Key (BOOK_CLUB_SEQ) — BIGINT — Foreign key → Untitled.Key — NOT NULL
  • Field (LEADER_YN) — BOOLEAN — NOT NULL
  • Field (JOIN_ST) — ENUM
  • Field (JOIN_ST_UPDATE_DTM) — TIMESTAMP
  • Key (MEMBER_SEQ) — BIGINT — Foreign key → Untitled.Key — NOT NULL

Untitled (BOOK_CLUB_REQUEST)

  • Key (BOOK_CLUB_REQUEST_SEQ) — BIGINT — Primary key — NOT NULL
  • Key (BOOK_CLUB_SEQ) — BIGINT — Foreign key → Untitled.Key — NOT NULL
  • Field (REQUEST_CONT) — TEXT
  • Field (REQUEST_ST) — ENUM — NOT NULL
  • Field (REQUEST_DTM) — TIMESTAMP — NOT NULL
  • Field (REQUEST_PROCESSED_DT) — DATE
  • Key (REQUEST_MEMBER_SEQ) — BIGINT — Foreign key → Untitled.Key — NOT NULL

Untitled (BOOK_CLUB_WISH)

  • Key (BOOK_CLUB_WISH_SEQ) — BIGINT — Primary key — NOT NULL
  • Key (BOOK_CLUB_SEQ) — BIGINT — Foreign key → Untitled.Key — NOT NULL
  • Field (CRT_DTM) — TIMESTAMP — NOT NULL
  • Key (MEMBER_SEQ) — BIGINT — Foreign key → Untitled.Key — NOT NULL

Untitled (BOOK_CLUB)

  • Key (BOOK_CLUB_SEQ) — BIGINT — Primary key — NOT NULL
  • Field (BOOK_CLUB_NAME) — VARCHAR(100) — NOT NULL
  • Field (BOOK_CLUB_DESC) — TEXT
  • Field (BOOK_CLUB_RG) — VARCHAR(50)
  • Field (BOOK_CLUB_MAX_MEMBER) — INT
  • Field (BOOK_CLUB_DELETED_DT) — DATE
  • Field (BANNER_IMG_URL) — VARCHAR(500)
  • Field (BOOK_CLUB_SCHEDULE) — VARCHAR(200)
  • Field (CRT_DTM) — TIMESTAMP — NOT NULL
  • Field (UPD_DTM) — TIMESTAMP
  • Key (BOOK_CLUB_LEADER_SEQ) — BIGINT — Foreign key → Untitled.Key — NOT NULL

Untitled (NOTICE)

  • Key (NOTICE_SEQ) — BIGINT — Primary key — NOT NULL
  • Key (ADMIN_SEQ) — BIGINT — Foreign key → Untitled.Key — NOT NULL
  • Field (NOTICE_TITLE) — VARCHAR(200)
  • Field (NOTICE_CONT) — TEXT
  • Field (CRT_DTM) — TIMESTAMP — NOT NULL
  • Field (UPD_DTM) — TIMESTAMP

Untitled (LOGIN_INFO)

  • Key (LOGIN_INFO_SEQ) — BIGINT — Primary key — NOT NULL
  • Key (ADMIN_SEQ) — BIGINT — Foreign key → Untitled.Key — NOT NULL
  • Field (LOGIN_DTM) — TIMESTAMP
  • Field (LOGIN_IP) — VARCHAR(45)
  • Field (LOGOUT_DTM) — TIMESTAMP

Untitled (ADMIN)

  • Key (ADMIN_SEQ) — BIGINT — Primary key — NOT NULL
  • Field (ADMIN_LOGIN_ID) — VARCHAR(50) — NOT NULL
  • Field (ADMIN_PASSWORD) — VARCHAR(255) — NOT NULL

Untitled (REPORT)

  • Key (REPOST_SEQ) — BIGINT — Primary key — NOT NULL
  • Key (MEMBER_SEQ) — BIGINT — Foreign key → Untitled.Key — NOT NULL
  • Field (REPORT_TITLE) — VARCHAR(200)
  • Field (REPORT_CONT) — CONT
  • Field (CRT_DTM) — TIMESTAMP — NOT NULL
  • Field (REPORT_IMG_URL) — VARCHAR(500)

Untitled (MEMBER_INFO)

  • Key (MEMBER_SEQ) — BIGINT — Primary key — NOT NULL
  • Field (LOGIN_ID) — VARCHAR(50) — NOT NULL
  • Field (MEMBER_PWD) — VARCHAR(255) — NOT NULL
  • Field (MEMBER_EMAIL) — VARCHAR(100) — NOT NULL
  • Field (MEMBER_TEL_NO) — VARCHAR(20)
  • Field (MEMBER_NICKNM) — VARCHAR(50) — NOT NULL
  • Field (MEMBER_DELETED_DTM) — TIMESTAMP
  • Field (MEMBER_LAST_LOGIN_DTM) — TIMESTAMP
  • Field (MEMBER_ST) — ENUM — NOT NULL
  • Field (CRT_DTM) — TIMESTAMP — NOT NULL
  • Field (UPD_DTM) — TIMESTAMP

Untitled (CHAT_MSG)

  • Key (CHAT_MSG_SEQ) — BIGINT — Primary key — NOT NULL
  • Key (CHAT_ROOM_SEQ) — BIGINT — Foreign key → Untitled2.Key — NOT NULL
  • Key (TRADE_SEQ) — BIGINT — Foreign key → Untitled2.Key — NOT NULL
  • Field (CHAT_CONT) — TEXT
  • Field (SENT_DTM) — TIMESTAMP
  • Field (READ_YN) — BOOLEAN

Untitled (BOOK_IMAGE)

  • Key (BOOK_IMG_SEQ) — BIGINT — Primary key — NOT NULL
  • Field (IMG_URL) — VARCHAR(500) — NOT NULL
  • Field (SORT_SEQ) — BIGININT

Untitled (SB_TRADE_INFO)

  • Key (TRADE_SEQ) — BIGINT — Primary key — NOT NULL
  • Key (MEMBER_SELLER_SEQ) — BIGINT — Foreign key → Untitled.Key — NOT NULL
  • Field (SALE_TITLE) — VARCHAR(200) — NOT NULL
  • Field (BOOK_ST) — ENUM — NOT NULL
  • Field (SALE_CONT) — TEXT
  • Field (SALE_PRICE) — INT — NOT NULL
  • Field (BOOK_DELIVERY_COST) — INT
  • Field (SALE_REGION_NM) — VARCHAR(100)
  • Field (SALE_ST) — ENUM — NOT NULL
  • Field (SALE_ST_DTM) — TIMESTAMP
  • Field (VIEWS) — BIGINT — NOT NULL
  • Field (WISH_CNT) — BIGINT — NOT NULL
  • Field (BOOK_SALE_DTM) — TIMESTAMP
  • Field (POST_NO) — VARCHAR(10) — NOT NULL
  • Field (ADDR_H) — VARCHAR(200) — NOT NULL
  • Field (ADDR_D) — VARCHAR(200) — NOT NULL
  • Field (RECIPIENT_PH_NO) — VARCHAR(20) — NOT NULL
  • Field (RECIPIENT_NM) — VARCHAR(50) — NOT NULL
  • Field (CRT_DTM) — TIMESTAMP — NOT NULL
  • Field (UPD_DTM) — TIMESTAMP
  • Field (PAYMENT_TYPE) — VARCHAR(20) — NOT NULL
  • Key (BOOK_INFO_SEQ) — BIGINT — Foreign key → Untitled2.Key — NOT NULL
  • Key (CATEGORY_SEQ) — BIGINT — Foreign key → Untitled2.Key — NOT NULL
  • Key (BOOK_IMG_SEQ) — BIGINT — Foreign key → Untitled.Key — NOT NULL
  • Key (MEMBER_BUYER_SEQ) — BIGINT — Foreign key → Untitled.Key — NOT NULL

Untitled2 (CHATROOM)

  • Key (CHAT_ROOM_SEQ) — BIGINT — Primary key — NOT NULL
  • Key (TRADE_SEQ) — BIGINT — Foreign key → Untitled.Key — NOT NULL
  • Field (LAST_MSG_DTM) — TIMESTAMP
  • Field (LAST_MSG) — TEXT
  • Field (CRT_DTM) — TIMESTAMP
  • Key (MEMBER_BUYER_SEQ) — BIGINT — Foreign key → Untitled.Key — NOT NULL

Untitled2 (SETTLEMENT)

  • Key (SETTLEMENT_SEQ) — BIGINT — Primary key — NOT NULL
  • Field (MEMBER_SELLER_SEQ) — BIGINT — NOT NULL
  • Field (MEMBER_BUYER_SEQ) — BIGINT — NOT NULL
  • Field (SALE_PRICE) — BIGINT — NOT NULL
  • Field (SETTLEMENT_ST) — ENUMN — NOT NULL
  • Field (CRT_DTM) — TIMESTAMP — NOT NULL
  • Key (TRADE_SEQ) — BIGINT — Foreign key → Untitled.Key — NOT NULL

Untitled2 (TRADE_WISH)

  • Key (TRADE_WISH_SEQ) — BIGINT — Primary key — NOT NULL
  • Key (TRADE_SEQ) — BIGINT — Foreign key → Untitled.Key — NOT NULL
  • Key (MEMBER_SEQ) — BIGINT — Foreign key → Untitled.Key — NOT NULL
  • Field (CRT_DTM) — TIMESTAMP — NOT NULL

Untitled2 (CATEGORY)

  • Key (CATEGORY_SEQ) — BIGINT — Primary key — NOT NULL
  • Field (CATEGORY_NM) — VARCHAR(50) — NOT NULL
  • Field (CATEGORY_SORT_SEQ) — BIGINT
  • Field (CRT_DTM) — TIMESTAMP — NOT NULL
  • Field (UPD_DTM) — TIMESTAMP

Untitled2 (BOOK_INFO)

  • Key (BOOK_INFO_SEQ) — BIGINT — Primary key — NOT NULL
  • Field (ISBN) — VARCHAR(20) — NOT NULL
  • Field (BOOK_TITLE) — VARCHRAR(200) — NOT NULL
  • Field (BOOK_AUTHOR) — VARCHAR(100)
  • Field (BOOK_PUBLISHER) — VARCHAR(100)
  • Field (BOOK_IMG) — VARCHAR(500)
  • Field (BOOK_ORG_PRICE) — INT